<?xml version="1.0" encoding="UTF-8"?>
<schema name="public">
    <table name="user_group">
        <remarks><![CDATA[group of users]]></remarks>
        <column name="user_group_id" isUnique="false" isPrimaryKey="false" isNotNull="false" isForeignKey="false" dataType="unknown" >
        </column>
        <column name="name" isUnique="false" isPrimaryKey="false" isNotNull="false" isForeignKey="false" dataType="unknown" >
        </column>
        <primaryKey name="user_group_pk">
            </columnRef name="user_group_id" order="0"/>
        </primaryKey>
    </table>
    <table name="user">
        <remarks><![CDATA[all application users]]></remarks>
        <column name="user_id" isUnique="false" isPrimaryKey="false" isNotNull="false" isForeignKey="false" dataType="unknown" >
        </column>
        <column name="login" isUnique="false" isPrimaryKey="false" isNotNull="false" isForeignKey="false" dataType="unknown" >
        </column>
        <column name="password" isUnique="false" isPrimaryKey="false" isNotNull="false" isForeignKey="false" dataType="unknown" >
        </column>
        <column name="user_group" isUnique="false" isPrimaryKey="false" isNotNull="false" isForeignKey="false" dataType="unknown" >
        </column>
        <primaryKey name="user_pk">
            </columnRef name="user_id" order="0"/>
        </primaryKey>
        <index name="unser_id_idx" unique="false" columnSortSequence="ASC">
            </columnRef name="user_id" order="0"/>
        </index>
        <foreignKey name="grou_user" referencedTable="user_group">
            </referencedColumn from="user_group" to="user_group_id">
        </foreignKey>
    </table>
</schema>